CREATE VIEW [dbo].[vSoaGroupSummaryProduct]
WITH SCHEMABINDING
AS
    SELECT  [Product].[PRODUCT_CODE] AS [GroupId],
            'Public' AS [ParentEntityTypeName],
            'Public Groups' AS [ParentEntityId],
            [Product].[PROD_TYPE] AS [GroupClassId],
            [Product].[TITLE] AS [Name]
      FROM  [dbo].[Product]
     WHERE  ( [Product].[PROD_TYPE] IN ( 'DUES', 'SUB', 'SEC', 'CHAPT', 'VOL',
                                         'MISC', 'COMMITTEE' ) )


GO
CREATE UNIQUE CLUSTERED INDEX [PK_vSoaGroupSummaryProduct] ON [dbo].[vSoaGroupSummaryProduct] ([GroupId]) ON [PRIMARY]
GO